Overview

Dataset statistics

Number of variables26
Number of observations292
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory72.0 KiB
Average record size in memory252.4 B

Variable types

NUM16
BOOL8
CAT1
DATE1

Reproduction

Analysis started2020-05-05 17:45:41.802661
Analysis finished2020-05-05 17:46:17.323133
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
udsventa has 57 (19.5%) zeros Zeros
udsprevisionempresa has 82 (28.1%) zeros Zeros
weekday has 41 (14.0%) zeros Zeros
sin_weekday has 41 (14.0%) zeros Zeros
roll4wd_udsventa has 50 (17.1%) zeros Zeros
roll4wd_udsstock has 16 (5.5%) zeros Zeros
udsprevisionempresa_shifted-1 has 83 (28.4%) zeros Zeros
udsprevisionempresa_shifted-2 has 84 (28.8%) zeros Zeros
udsstock_shifted7 has 7 (2.4%) zeros Zeros
roll4wd_udsstock_shifted1 has 17 (5.8%) zeros Zeros
roll4wd_udsstock_shifted7 has 23 (7.9%) zeros Zeros
udsventa_shifted1 has 57 (19.5%) zeros Zeros

Variables

fecha
Date

UNIFORM
UNIQUE
Distinct count292
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2019-06-05 00:00:00
Maximum2020-03-22 00:00:00
Histogram

producto
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
32
292
ValueCountFrequency (%) 
32 292 100.0%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Decimal_Number 2 100.0%
 
ValueCountFrequency (%) 
Common 2 100.0%
 
ValueCountFrequency (%) 
ASCII 2 100.0%
 

udsstock
Real number (ℝ≥0)

Distinct count97
Unique (%)33.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1130.034616228127
Minimum129.0
Maximum2416.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum129
5-th percentile588.15
Q1886.6923077
median1113.433333
Q31366.7
95-th percentile1760.25
Maximum2416
Range2287
Interquartile range (IQR)480.0076923

Descriptive statistics

Standard deviation369.0802513
Coefficient of variation (CV)0.3266096861
Kurtosis0.8888383955
Mean1130.034616
Median Absolute Deviation (MAD)286.2371716
Skewness0.3886536348
Sum329970.1079
Variance136220.2319
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 129. 607. 882.34615385 888.84615385 1020.63333333 ... 1361.35 1390.19642857 1530.5 1853.5 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
886.6923077 25 8.6%
 
1021.266667 14 4.8%
 
1385.392857 13 4.5%
 
1366.7 12 4.1%
 
1113.433333 11 3.8%
 
1243.344828 11 3.8%
 
878 6 2.1%
 
1511 6 2.1%
 
672 5 1.7%
 
788 5 1.7%
 
Other values (87) 184 63.0%
 
ValueCountFrequency (%) 
129 1 0.3%
 
155 1 0.3%
 
323 1 0.3%
 
362 1 0.3%
 
374 2 0.7%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2274 2 0.7%
 
2219 1 0.3%
 
2157 2 0.7%
 
2080 1 0.3%
 

udsventa
Real number (ℝ≥0)

ZEROS
Distinct count91
Unique (%)31.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean500.56164383561645
Minimum0.0
Maximum2410.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1285
median511
Q3698
95-th percentile1047.05
Maximum2410
Range2410
Interquartile range (IQR)413

Descriptive statistics

Standard deviation360.328477
Coefficient of variation (CV)0.7198483571
Kurtosis3.128100968
Mean500.5616438
Median Absolute Deviation (MAD)271.7311878
Skewness0.905171123
Sum146164
Variance129836.6113
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 73.5 270. 811. 1160.5 2410. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
688 8 2.7%
 
472 7 2.4%
 
639 7 2.4%
 
423 6 2.1%
 
442 6 2.1%
 
560 6 2.1%
 
492 6 2.1%
 
708 5 1.7%
 
511 5 1.7%
 
Other values (81) 179 61.3%
 
ValueCountFrequency (%) 
0 57 19.5%
 
147 1 0.3%
 
186 1 0.3%
 
196 1 0.3%
 
206 1 0.3%
 
ValueCountFrequency (%) 
2410 1 0.3%
 
1889 1 0.3%
 
1800 1 0.3%
 
1751 1 0.3%
 
1535 1 0.3%
 

udsprevisionempresa
Real number (ℝ≥0)

ZEROS
Distinct count193
Unique (%)66.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2248.77397260274
Minimum0.0
Maximum19542.0
Zeros82
Zeros (%)28.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1659.5
Q33460
95-th percentile6803.55
Maximum19542
Range19542
Interquartile range (IQR)3460

Descriptive statistics

Standard deviation2563.018003
Coefficient of variation (CV)1.139740158
Kurtosis10.13146741
Mean2248.773973
Median Absolute Deviation (MAD)1851.605132
Skewness2.375309942
Sum656642
Variance6569061.282
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 3902. 6076.5 9524.5 19542. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 82 28.1%
 
2371 3 1.0%
 
1613 2 0.7%
 
1399 2 0.7%
 
1676 2 0.7%
 
3140 2 0.7%
 
1865 2 0.7%
 
3788 2 0.7%
 
3825 2 0.7%
 
4227 2 0.7%
 
Other values (183) 191 65.4%
 
ValueCountFrequency (%) 
0 82 28.1%
 
51 1 0.3%
 
129 2 0.7%
 
159 1 0.3%
 
216 1 0.3%
 
ValueCountFrequency (%) 
19542 1 0.3%
 
16054 1 0.3%
 
13299 1 0.3%
 
9635 1 0.3%
 
9414 1 0.3%
 

promo
Boolean

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
292
ValueCountFrequency (%) 
0 292 100.0%
 

festivo
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
284
1
 
8
ValueCountFrequency (%) 
0 284 97.3%
 
1 8 2.7%
 

weekday
Real number (ℝ≥0)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.017123287671233
Minimum0
Maximum6
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q35
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.999067122
Coefficient of variation (CV)0.662573893
Kurtosis-1.24431598
Mean3.017123288
Median Absolute Deviation (MAD)1.711249765
Skewness-0.01071552041
Sum881
Variance3.996269359
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 5.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 
1 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
0 41 14.0%
 
1 41 14.0%
 
2 42 14.4%
 
3 42 14.4%
 
4 42 14.4%
 
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 

working_day
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
True
242
False
50
ValueCountFrequency (%) 
True 242 82.9%
 
False 50 17.1%
 

sin_weekday
Real number (ℝ)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.002677505076945293
Minimum-0.9749279121818236
Maximum0.9749279121818236
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9749279122
5-th percentile-0.9749279122
Q1-0.7818314825
median0
Q30.7818314825
95-th percentile0.9749279122
Maximum0.9749279122
Range1.949855824
Interquartile range (IQR)1.563662965

Descriptive statistics

Standard deviation0.7092579884
Coefficient of variation (CV)-264.895105
Kurtosis-1.507989269
Mean-0.002677505077
Median Absolute Deviation (MAD)0.6278742875
Skewness0.006768729133
Sum-0.7818314825
Variance0.5030468941
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.97492791 -0.8783797 0.8783797 0.97492791], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.4338837391 42 14.4%
 
0.4338837391 42 14.4%
 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
-0.4338837391 42 14.4%
 
0 41 14.0%
 
0.4338837391 42 14.4%
 
ValueCountFrequency (%) 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0.4338837391 42 14.4%
 
0 41 14.0%
 
-0.4338837391 42 14.4%
 

cos_weekday
Real number (ℝ)

Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.005559896581708024
Minimum-0.9009688679024191
Maximum1.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9009688679
5-th percentile-0.9009688679
Q1-0.9009688679
median-0.222520934
Q30.6234898019
95-th percentile1
Maximum1
Range1.900968868
Interquartile range (IQR)1.52445867

Descriptive statistics

Standard deviation0.7073551581
Coefficient of variation (CV)-127.2245172
Kurtosis-1.502452694
Mean-0.005559896582
Median Absolute Deviation (MAD)0.6399937036
Skewness0.01159750905
Sum-1.623489802
Variance0.5003513197
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.90096887 -0.90096887 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
0.6234898019 42 14.4%
 
0.6234898019 41 14.0%
 
1 41 14.0%
 
ValueCountFrequency (%) 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
0.6234898019 42 14.4%
 
ValueCountFrequency (%) 
1 41 14.0%
 
0.6234898019 41 14.0%
 
0.6234898019 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 

is_august
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
261
1
 
31
ValueCountFrequency (%) 
0 261 89.4%
 
1 31 10.6%
 

spring
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
291
1
 
1
ValueCountFrequency (%) 
0 291 99.7%
 
1 1 0.3%
 

summer
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
184
1
108
ValueCountFrequency (%) 
0 184 63.0%
 
1 108 37.0%
 

autumn
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
202
1
90
ValueCountFrequency (%) 
0 202 69.2%
 
1 90 30.8%
 

winter
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
200
1
92
ValueCountFrequency (%) 
0 200 68.5%
 
1 92 31.5%
 

roll4wd_udsventa
Real number (ℝ≥0)

ZEROS
Distinct count232
Unique (%)79.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean503.48763454011737
Minimum0.0
Maximum1294.875
Zeros50
Zeros (%)17.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1352.5
median553
Q3690
95-th percentile948.3991071
Maximum1294.875
Range1294.875
Interquartile range (IQR)337.5

Descriptive statistics

Standard deviation289.6984597
Coefficient of variation (CV)0.5753834649
Kurtosis-0.3711887023
Mean503.4876345
Median Absolute Deviation (MAD)226.3199039
Skewness-0.3306824771
Sum147018.3893
Variance83925.19754
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 105.85714286 269.125 469.375 761.5625 1018.9 1294.875 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50 17.1%
 
503.875 3 1.0%
 
560 2 0.7%
 
545.625 2 0.7%
 
692 2 0.7%
 
913.625 2 0.7%
 
601.125 2 0.7%
 
451 2 0.7%
 
352.5 2 0.7%
 
524.875 2 0.7%
 
Other values (222) 223 76.4%
 
ValueCountFrequency (%) 
0 50 17.1%
 
211.7142857 1 0.3%
 
226.875 1 0.3%
 
265.25 1 0.3%
 
273 1 0.3%
 
ValueCountFrequency (%) 
1294.875 1 0.3%
 
1133 1 0.3%
 
1105.857143 1 0.3%
 
1101.6 1 0.3%
 
1073.571429 1 0.3%
 

roll4wd_udsstock
Real number (ℝ≥0)

ZEROS
Distinct count239
Unique (%)81.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1094.7101149706457
Minimum0.0
Maximum2416.0
Zeros16
Zeros (%)5.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1839.6875
median1113.4375
Q31382
95-th percentile1781.580357
Maximum2416
Range2416
Interquartile range (IQR)542.3125

Descriptive statistics

Standard deviation445.0093937
Coefficient of variation (CV)0.40650889
Kurtosis0.7201320193
Mean1094.710115
Median Absolute Deviation (MAD)335.3098296
Skewness-0.2989982605
Sum319655.3536
Variance198033.3605
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 181. 457.125 704.4375 1535.4375 1815. 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 16 5.5%
 
710 10 3.4%
 
1072 5 1.7%
 
2157 3 1.0%
 
1382 3 1.0%
 
1279 3 1.0%
 
1925 2 0.7%
 
1460 2 0.7%
 
1013.75 2 0.7%
 
1076.75 2 0.7%
 
Other values (229) 244 83.6%
 
ValueCountFrequency (%) 
0 16 5.5%
 
362 1 0.3%
 
452.25 1 0.3%
 
462 1 0.3%
 
468.25 1 0.3%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2219 1 0.3%
 
2157 3 1.0%
 
2093 1 0.3%
 
2042 1 0.3%
 

udsprevisionempresa_shifted-1
Real number (ℝ≥0)

ZEROS
Distinct count192
Unique (%)65.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2203.2294520547944
Minimum0.0
Maximum19542.0
Zeros83
Zeros (%)28.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1628
Q33436.5
95-th percentile6703.3
Maximum19542
Range19542
Interquartile range (IQR)3436.5

Descriptive statistics

Standard deviation2482.890335
Coefficient of variation (CV)1.126932255
Kurtosis10.71423133
Mean2203.229452
Median Absolute Deviation (MAD)1813.624906
Skewness2.360600756
Sum643343
Variance6164744.418
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 3902. 6076.5 9524.5 19542. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 83 28.4%
 
2371 3 1.0%
 
1613 2 0.7%
 
1399 2 0.7%
 
303 2 0.7%
 
1676 2 0.7%
 
1865 2 0.7%
 
3788 2 0.7%
 
3825 2 0.7%
 
3259 2 0.7%
 
Other values (182) 190 65.1%
 
ValueCountFrequency (%) 
0 83 28.4%
 
51 1 0.3%
 
129 2 0.7%
 
159 1 0.3%
 
216 1 0.3%
 
ValueCountFrequency (%) 
19542 1 0.3%
 
16054 1 0.3%
 
9635 1 0.3%
 
9414 1 0.3%
 
8942 1 0.3%
 

udsprevisionempresa_shifted-2
Real number (ℝ≥0)

ZEROS
Distinct count191
Unique (%)65.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2136.304794520548
Minimum0.0
Maximum16054.0
Zeros84
Zeros (%)28.8%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1613
Q33410.5
95-th percentile6374.6
Maximum16054
Range16054
Interquartile range (IQR)3410.5

Descriptive statistics

Standard deviation2268.000951
Coefficient of variation (CV)1.061646708
Kurtosis4.922702659
Mean2136.304795
Median Absolute Deviation (MAD)1751.321238
Skewness1.637135046
Sum623801
Variance5143828.316
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 3902. 6076.5 9524.5 16054. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 84 28.8%
 
2371 3 1.0%
 
2822 2 0.7%
 
1094 2 0.7%
 
3140 2 0.7%
 
1865 2 0.7%
 
3788 2 0.7%
 
3825 2 0.7%
 
129 2 0.7%
 
4227 2 0.7%
 
Other values (181) 189 64.7%
 
ValueCountFrequency (%) 
0 84 28.8%
 
51 1 0.3%
 
129 2 0.7%
 
159 1 0.3%
 
216 1 0.3%
 
ValueCountFrequency (%) 
16054 1 0.3%
 
9635 1 0.3%
 
9414 1 0.3%
 
8942 1 0.3%
 
8564 1 0.3%
 

udsstock_shifted1
Real number (ℝ≥0)

Distinct count98
Unique (%)33.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1126.1407806116888
Minimum0.0
Maximum2416.0
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile581
Q1886.6923077
median1113.433333
Q31366.7
95-th percentile1760.25
Maximum2416
Range2416
Interquartile range (IQR)480.0076923

Descriptive statistics

Standard deviation374.9574542
Coefficient of variation (CV)0.3329578865
Kurtosis0.9504656482
Mean1126.140781
Median Absolute Deviation (MAD)289.7632578
Skewness0.307317622
Sum328833.1079
Variance140593.0925
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 607. 882.34615385 888.84615385 1020.63333333 ... 1361.35 1390.19642857 1530.5 1853.5 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
886.6923077 25 8.6%
 
1021.266667 14 4.8%
 
1385.392857 13 4.5%
 
1366.7 12 4.1%
 
1113.433333 11 3.8%
 
1243.344828 11 3.8%
 
878 6 2.1%
 
1511 6 2.1%
 
1111 5 1.7%
 
788 5 1.7%
 
Other values (88) 184 63.0%
 
ValueCountFrequency (%) 
0 1 0.3%
 
129 1 0.3%
 
155 1 0.3%
 
323 1 0.3%
 
362 1 0.3%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2274 2 0.7%
 
2219 1 0.3%
 
2157 2 0.7%
 
2080 1 0.3%
 

udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count98
Unique (%)33.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1108.1805066390862
Minimum0.0
Maximum2416.0
Zeros7
Zeros (%)2.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile408.45
Q1886.6923077
median1111
Q31366.7
95-th percentile1760.25
Maximum2416
Range2416
Interquartile range (IQR)480.0076923

Descriptive statistics

Standard deviation403.5124784
Coefficient of variation (CV)0.3641216174
Kurtosis1.139197854
Mean1108.180507
Median Absolute Deviation (MAD)305.1497095
Skewness-0.03785759459
Sum323588.7079
Variance162822.3202
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 607. 882.34615385 888.84615385 1014. ... 1361.35 1390.19642857 1530.5 1853.5 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
886.6923077 25 8.6%
 
1385.392857 13 4.5%
 
1021.266667 13 4.5%
 
1243.344828 11 3.8%
 
1366.7 11 3.8%
 
1113.433333 10 3.4%
 
0 7 2.4%
 
1511 6 2.1%
 
878 6 2.1%
 
672 5 1.7%
 
Other values (88) 185 63.4%
 
ValueCountFrequency (%) 
0 7 2.4%
 
129 1 0.3%
 
155 1 0.3%
 
323 1 0.3%
 
362 1 0.3%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2274 2 0.7%
 
2219 1 0.3%
 
2157 2 0.7%
 
2080 1 0.3%
 

roll4wd_udsstock_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count238
Unique (%)81.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1092.67655332681
Minimum0.0
Maximum2416.0
Zeros17
Zeros (%)5.8%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1839.6875
median1113.4375
Q31382
95-th percentile1781.580357
Maximum2416
Range2416
Interquartile range (IQR)542.3125

Descriptive statistics

Standard deviation448.6481399
Coefficient of variation (CV)0.4105955587
Kurtosis0.7127278922
Mean1092.676553
Median Absolute Deviation (MAD)337.3812915
Skewness-0.3235403106
Sum319061.5536
Variance201285.1535
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 181. 457.125 704.4375 1535.4375 1815. 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 17 5.8%
 
710 10 3.4%
 
1072 5 1.7%
 
1279 3 1.0%
 
2157 3 1.0%
 
1382 3 1.0%
 
1278.8 2 0.7%
 
1307.75 2 0.7%
 
947.625 2 0.7%
 
1414.625 2 0.7%
 
Other values (228) 243 83.2%
 
ValueCountFrequency (%) 
0 17 5.8%
 
362 1 0.3%
 
452.25 1 0.3%
 
462 1 0.3%
 
468.25 1 0.3%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2219 1 0.3%
 
2157 3 1.0%
 
2093 1 0.3%
 
2042 1 0.3%
 

roll4wd_udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count233
Unique (%)79.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1072.7386130136986
Minimum0.0
Maximum2416.0
Zeros23
Zeros (%)7.9%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1814.025
median1096.071429
Q31382
95-th percentile1781.580357
Maximum2416
Range2416
Interquartile range (IQR)567.975

Descriptive statistics

Standard deviation472.9505115
Coefficient of variation (CV)0.4408814092
Kurtosis0.5154957632
Mean1072.738613
Median Absolute Deviation (MAD)355.0955665
Skewness-0.4018637958
Sum313239.675
Variance223682.1863
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 181. 457.125 941.375 1535.4375 1815. 2416. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 23 7.9%
 
710 10 3.4%
 
1072 5 1.7%
 
1279 3 1.0%
 
2157 3 1.0%
 
1382 3 1.0%
 
1228.857143 2 0.7%
 
806.2857143 2 0.7%
 
952.375 2 0.7%
 
1013.75 2 0.7%
 
Other values (223) 237 81.2%
 
ValueCountFrequency (%) 
0 23 7.9%
 
362 1 0.3%
 
452.25 1 0.3%
 
462 1 0.3%
 
468.25 1 0.3%
 
ValueCountFrequency (%) 
2416 1 0.3%
 
2219 1 0.3%
 
2157 3 1.0%
 
2093 1 0.3%
 
2042 1 0.3%
 

udsventa_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count91
Unique (%)31.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean500.56164383561645
Minimum0.0
Maximum2410.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1285
median511
Q3698
95-th percentile1047.05
Maximum2410
Range2410
Interquartile range (IQR)413

Descriptive statistics

Standard deviation360.328477
Coefficient of variation (CV)0.7198483571
Kurtosis3.128100968
Mean500.5616438
Median Absolute Deviation (MAD)271.7311878
Skewness0.905171123
Sum146164
Variance129836.6113
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 73.5 270. 811. 1160.5 2410. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
688 8 2.7%
 
639 7 2.4%
 
472 7 2.4%
 
492 6 2.1%
 
560 6 2.1%
 
442 6 2.1%
 
423 6 2.1%
 
738 5 1.7%
 
511 5 1.7%
 
Other values (81) 179 61.3%
 
ValueCountFrequency (%) 
0 57 19.5%
 
147 1 0.3%
 
186 1 0.3%
 
196 1 0.3%
 
206 1 0.3%
 
ValueCountFrequency (%) 
2410 1 0.3%
 
1889 1 0.3%
 
1800 1 0.3%
 
1751 1 0.3%
 
1535 1 0.3%
 

roll4_udstock_shifted1
Real number (ℝ≥0)

Distinct count270
Unique (%)92.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1122.575455269223
Minimum0.0
Maximum1931.5
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile669.84375
Q1965.5003205
median1119.393289
Q31288.672729
95-th percentile1512.341875
Maximum1931.5
Range1931.5
Interquartile range (IQR)323.1724089

Descriptive statistics

Standard deviation265.0619151
Coefficient of variation (CV)0.2361194643
Kurtosis1.392785056
Mean1122.575455
Median Absolute Deviation (MAD)204.2517983
Skewness-0.3931131749
Sum327792.0329
Variance70257.81885
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 578.625 877.6125 1297.72045874 1582.1516744 1931.5 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1267.45067 5 1.7%
 
1118.286579 5 1.7%
 
1291.120084 3 1.0%
 
965.8516712 3 1.0%
 
1213.126437 3 1.0%
 
965.5003205 3 1.0%
 
1082.186538 3 1.0%
 
1067.125 2 0.7%
 
1170.625 2 0.7%
 
1189.75 2 0.7%
 
Other values (260) 261 89.4%
 
ValueCountFrequency (%) 
0 1 0.3%
 
119.5 1 0.3%
 
400.1 1 0.3%
 
503.4083333 1 0.3%
 
568 1 0.3%
 
ValueCountFrequency (%) 
1931.5 1 0.3%
 
1923.5 1 0.3%
 
1737.799107 1 0.3%
 
1652.711538 1 0.3%
 
1647 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
02019-06-0532478.000000560.013299.00.00.02True0.974928-0.22252100100560.0478.019542.016054.00.0000000.0000000.00.00.00.000000
12019-06-06321366.700000806.019542.00.00.03True0.433884-0.90096900100806.00.016054.03572.0478.0000000.000000478.00.0560.0119.500000
22019-06-07321243.344828856.016054.00.00.04True-0.433884-0.90096900100856.00.03572.00.01366.7000000.0000000.00.0806.0400.100000
32019-06-08321385.392857275.03572.00.00.05True-0.974928-0.22252100100275.00.00.04646.01243.3448280.0000000.00.0856.0847.180603
42019-06-0932886.6923080.00.00.00.06False-0.7818310.623490001000.00.04646.03438.01385.3928570.0000000.00.0275.01211.690917
52019-06-1032886.692308492.04646.00.00.00True0.0000001.00000000100492.00.03438.01448.0886.6923080.0000000.00.00.01267.450670
62019-06-11322157.000000570.03438.00.00.01True0.7818310.62349000100570.02157.01448.02969.0886.6923080.0000000.00.0492.01118.286579
72019-06-12321834.000000688.01448.00.00.02True0.974928-0.22252100100592.0817.02969.04795.02157.000000478.0000002157.0478.0570.01107.818338
82019-06-1332362.000000590.02969.00.00.03True0.433884-0.90096900100752.0362.04795.01597.01834.0000001366.700000817.00.0688.01481.471154
92019-06-14321382.0000001092.04795.00.00.04True-0.433884-0.90096900100915.01382.01597.00.0362.0000001243.344828362.00.0590.01652.711538

Last rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
2822020-03-13321243.3448281535.07132.00.00.04True-0.433884-0.90096900001883.8751098.0000000.00.01366.7000001243.3448281460.0000001224.000000364.01024.336538
2832020-03-1432762.0000001751.00.00.00.05True-0.974928-0.22252100001512.6251023.7500000.01389.01243.3448281385.3928571098.0000001111.0000001535.01193.843103
2842020-03-1532374.0000000.00.00.00.06False-0.7818310.623490000010.000626.0000001389.01810.0762.000000886.6923081023.750000710.0000001751.01213.195977
2852020-03-1632374.000000432.01389.00.00.00True0.0000001.00000000001614.375635.2000001810.03089.0374.000000886.692308626.000000686.4285710.0969.591810
2862020-03-17321021.2666671800.01810.00.00.01True0.7818310.62349000001554.125871.4285713089.03140.0374.000000867.000000635.200000870.250000432.0628.168103
2872020-03-18321113.433333600.03089.00.00.02True0.974928-0.22252100001490.2501178.7500003140.03776.01021.2666671113.433333871.4285711122.1428571800.0503.408333
2882020-03-19321366.7000001889.03140.00.00.03True0.433884-0.90096900001727.7501460.0000003776.00.01113.4333331366.7000001178.7500001460.000000600.0709.154167
2892020-03-2032581.0000002410.03776.00.00.04True-0.433884-0.900969000011294.875839.5000000.00.01366.7000001243.3448281460.0000001098.0000001889.01018.100000
2902020-03-2132788.000000403.00.00.00.05True-0.974928-0.22252100001852.000837.0000000.00.0581.000000762.000000839.5000001023.7500002410.01130.333333
2912020-03-22321137.0000000.00.00.00.06False-0.7818310.623490010010.000593.8000000.00.0788.000000374.000000837.000000626.000000403.0968.066667